package Dao;

import bean.customer;

import java.sql.SQLException;
import java.util.List;

public interface customerDao {

    public int addCustomer(customer customer);
    public int deleteCustomerBYId(Integer id);
    public int deleteCustomerBYPhoneNumber(String phoneNumber);
    public int updateCustomer(customer customer);
    public customer queryCustomerById(Integer id);

    public Integer queryIdByPhoneNumber(String phonenumber) throws Exception;
    public customer queryCustomerByPhoneNumber(String phonenumber);
    public List<customer> queryCustomers() throws Exception;

}
